1. Overview SQLite contains its own implementation of the string formatting routine "printf()", accessible via the following interfaces: format() → an SQL function returning the formatted string sqlite3_mprintf() → Store the formatted string in memory obtained sqlite3_malloc64(). sqlite3_snprintf() → Store the formatted ... 

sqlite3_reset()

 ... If sqlite3_step(S) has never before been called on S or if sqlite3_step(S) has not been called since the previous call to sqlite3_reset(S), then sqlite3_reset(S) will return SQLITE_OK. If the most recent call to sqlite3_step(S) for ... 

sqlite3_stmt_explain()

The sqlite3_stmt_explain(S,E) interface changes the EXPLAIN setting for prepared statement S. If E is zero, then S becomes a normal prepared statement. If E is 1, then S behaves as if its SQL text began with "EXPLAIN". If ... 

sqlite3_stmt_busy()

The sqlite3_stmt_busy(S) interface returns true (non-zero) if the prepared statement S has been stepped at least once using sqlite3_step(S) but has neither run to completion (returned SQLITE_DONE from sqlite3_step(S)) nor been reset using sqlite3_reset(S). The ... 

sqlite3_stmt_isexplain()

The sqlite3_stmt_isexplain(S) interface returns 1 if the prepared statement S is an EXPLAIN statement, or 2 if the statement S is an EXPLAIN QUERY PLAN. The sqlite3_stmt_isexplain(S) interface returns 0 if S is an ordinary statement or a ... 

sqlite3_txn_state()

The sqlite3_txn_state(D,S) interface returns the current transaction state of schema S in database connection D. If S is NULL, then the highest transaction state of any schema on database connection D is returned. Transaction states are (in order ... 

sqlite3_snapshot_get()

The sqlite3_snapshot_get(D,S,P) interface attempts to make a new sqlite3_snapshot object that records the current state of schema S in database connection D. On success, the sqlite3_snapshot_get(D,S,P) interface writes a pointer to the newly created ... 

sqlite3_finalize()

 ... If the most recent evaluation of statement S failed, then sqlite3_finalize(S) returns the appropriate error code or extended error code. The sqlite3_finalize(S) routine can be called at any point during the life cycle of prepared statement S: before ... 

sqlite3_deserialize()

The sqlite3_deserialize(D,S,P,N,M,F) interface causes the database connection D to disconnect from database S and then reopen S as an in-memory database based on the serialization contained in P. The serialized database P is ... 

sqlite3_snapshot_open()

The sqlite3_snapshot_open(D,S,P) interface either starts a new read transaction or upgrades an existing one for schema S of database connection D such that the read transaction refers to historical snapshot P, rather than the most recent change ...